/*
 Navicat Premium Data Transfer

 Source Server         : localhostDB
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : localhost:3306
 Source Schema         : FloretExaminactionSystem

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 18/06/2021 21:08:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for 2006831
-- ----------------------------
DROP TABLE IF EXISTS `2006831`;
CREATE TABLE `2006831` (
  `studentName` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `studentNumber` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `studentPass` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `studentEmail` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `数学` float(4,1) DEFAULT NULL COMMENT '数学',
  PRIMARY KEY (`studentNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='软件工程2020级专升本1班';

-- ----------------------------
-- Records of 2006831
-- ----------------------------
BEGIN;
INSERT INTO `2006831` VALUES ('王皓', '2006831513', '123456', '1756244343@qq.com', NULL);
INSERT INTO `2006831` VALUES ('张健强', '2006831517', 'e10adc3949ba59abbe56e057f20f883e', '1122@qq.com', NULL);
INSERT INTO `2006831` VALUES ('陈羽婷', '2006831520', '123456', '2246941123@qq.com', NULL);
INSERT INTO `2006831` VALUES ('代利君', '2006831521', '123456', '12334@qq.com', NULL);
INSERT INTO `2006831` VALUES ('叶魏', '2006831526', '123456', '444@qq.com', NULL);
COMMIT;

-- ----------------------------
-- Table structure for 2006831-2953694188
-- ----------------------------
DROP TABLE IF EXISTS `2006831-2953694188`;
CREATE TABLE `2006831-2953694188` (
  `studentNumber` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `rightOption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`studentNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of 2006831-2953694188
-- ----------------------------
BEGIN;
INSERT INTO `2006831-2953694188` VALUES ('2006831517', '[[0,\"2.5\"],[0,\"-7\"]]');
COMMIT;

-- ----------------------------
-- Table structure for 2006832
-- ----------------------------
DROP TABLE IF EXISTS `2006832`;
CREATE TABLE `2006832` (
  `studentName` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `studentNumber` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `studentPass` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `studentEmail` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`studentNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='软件工程2020级专升本2班';

-- ----------------------------
-- Records of 2006832
-- ----------------------------
BEGIN;
INSERT INTO `2006832` VALUES ('张健强', '2006832517', '123456', 'scitctocdtu@qq.com');
COMMIT;

-- ----------------------------
-- Table structure for 2953694188
-- ----------------------------
DROP TABLE IF EXISTS `2953694188`;
CREATE TABLE `2953694188` (
  `ID` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `questionName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试题题目',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '题型',
  `score` int NOT NULL COMMENT '分值',
  `optionList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '选项列表',
  `rightOption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '正确选项',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='试题库模板';

-- ----------------------------
-- Records of 2953694188
-- ----------------------------
BEGIN;
INSERT INTO `2953694188` VALUES (1, '10/4=( )', 'radio', 1, '36&2.5&57&75', '2.5');
INSERT INTO `2953694188` VALUES (2, '1-8=( )', 'radio', 1, '-7&54&44&59', '-7');
COMMIT;

-- ----------------------------
-- Table structure for classManage
-- ----------------------------
DROP TABLE IF EXISTS `classManage`;
CREATE TABLE `classManage` (
  `className` varchar(30) COLLATE utf8mb4_general_ci NOT NULL COMMENT '班级名称',
  `classNumber` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT '班级号',
  PRIMARY KEY (`classNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='班级目录';

-- ----------------------------
-- Records of classManage
-- ----------------------------
BEGIN;
INSERT INTO `classManage` VALUES ('软件工程2020级专升本1班', '2006831');
INSERT INTO `classManage` VALUES ('软件工程2020级专升本2班', '2006832');
COMMIT;

-- ----------------------------
-- Table structure for examinationRecord
-- ----------------------------
DROP TABLE IF EXISTS `examinationRecord`;
CREATE TABLE `examinationRecord` (
  `ID` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `teacherNumber` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '教师工号',
  `classNumber` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '班级号',
  `coursesName` varchar(30) COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程名',
  `startTime` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开始时间',
  `endTime` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '结束时间',
  `questionBank` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '试题库',
  PRIMARY KEY (`ID`),
  KEY `classNumber` (`classNumber`),
  KEY `teacherNumber` (`teacherNumber`),
  CONSTRAINT `examinationrecord_ibfk_1` FOREIGN KEY (`classNumber`) REFERENCES `classManage` (`classNumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `examinationrecord_ibfk_2` FOREIGN KEY (`teacherNumber`) REFERENCES `teacher` (`teacherNumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='考试记录';

-- ----------------------------
-- Records of examinationRecord
-- ----------------------------
BEGIN;
INSERT INTO `examinationRecord` VALUES (1, '2006831514', '2006831', '数学', '2021-06-07 17:01', '2021-06-07 17:52', '2953694188');
COMMIT;

-- ----------------------------
-- Table structure for questionBank
-- ----------------------------
DROP TABLE IF EXISTS `questionBank`;
CREATE TABLE `questionBank` (
  `ID` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `questionName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '试题题目',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '题型',
  `score` int NOT NULL COMMENT '分值',
  `optionList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '选项列表',
  `rightOption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '正确选项',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='试题库模板';

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `teacherName` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '教师名',
  `teacherNumber` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '教师编号',
  `teacherPass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `teacherEmail` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮箱',
  PRIMARY KEY (`teacherNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='教师信息';

-- ----------------------------
-- Records of teacher
-- ----------------------------
BEGIN;
INSERT INTO `teacher` VALUES ('王彦钧', '2006831514', 'e10adc3949ba59abbe56e057f20f883e', '93111111931@qq.com');
INSERT INTO `teacher` VALUES ('张健强', '2006831517', '123456', '1634119605@qq.com');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
